Dataset statistics
| Number of variables | 103 |
|---|---|
| Number of observations | 508031 |
| Missing cells | 20901650 |
| Missing cells (%) | 39.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 399.2 MiB |
| Average record size in memory | 824.0 B |
Variable types
| CAT | 45 |
|---|---|
| UNSUPPORTED | 42 |
| NUM | 8 |
| BOOL | 8 |
Reproduction
| Analysis started | 2020-06-10 08:08:28.195435 |
|---|---|
| Analysis finished | 2020-06-10 08:17:08.617721 |
| Duration | 8 minutes and 40.42 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
ACCOUNT_BALANCE has constant value "0" | Constant |
ACCOUNT_PURPOSE has constant value "DIARIO" | Constant |
ACCOUNT_SEGMENT has constant value "1" | Constant |
BALANCE_DATE has constant value "2018" | Constant |
BENEFICIARY_FLAG has constant value "N" | Constant |
BLOCKED_REASON has constant value "HIGH ACTIVITY" | Constant |
BLOCKED_TYPE has constant value "Y" | Constant |
CHANNEL_OF_OPENING has constant value "INTERNET" | Constant |
CREDIT_LIMIT has constant value "2000" | Constant |
CREDIT_TURNOVER has constant value "Y" | Constant |
CURRENCY_CODE has constant value "EUR" | Constant |
CUSTOMER_SEGMENT_1 has constant value "1" | Constant |
CUSTOMER_STATUS_CODE has constant value "1" | Constant |
CUSTOMER_TYPE_CODE has constant value "P" | Constant |
DEBIT_TRUNOVER has constant value "N" | Constant |
EMPLOYMENT_STATUS has constant value "Desempleado" | Constant |
LIFE_INS_CONTRACT_DURATION has constant value "0" | Constant |
OCCUPATION has constant value "Camarero" | Constant |
ORG_UNIT_CODE has constant value "RET" | Constant |
OVERDRAFT_LIMIT has constant value "0" | Constant |
PAYMENT_FREQ has constant value "Diario" | Constant |
PAYMENT_METHOD has constant value "Transferencia" | Constant |
PERIODIC_LOAN_AMOUNT has constant value "0" | Constant |
REPORTING_REGION has constant value "Y" | Constant |
RISK_CATEGORY has constant value "PEP" | Constant |
RISK_SCORE has constant value "100" | Constant |
TOTAL_LOANS_BASE has constant value "200" | Constant |
ISSUE_DATE has a high cardinality: 24217 distinct values | High cardinality |
ORIGINATION_DATE has a high cardinality: 24218 distinct values | High cardinality |
PRODUCT_SOURCE_TYPE_CODE has a high cardinality: 10966 distinct values | High cardinality |
TXN_SOURCE_TYPE_CODE has a high cardinality: 9030 distinct values | High cardinality |
PRIME_BRANCH_ID is highly correlated with BRANCH_ID and 1 other fields | High correlation |
BRANCH_ID is highly correlated with PRIME_BRANCH_ID and 1 other fields | High correlation |
RELATIONSHIP_MGR_ID is highly correlated with BRANCH_ID and 1 other fields | High correlation |
TXN_CHANNEL_CODE is highly correlated with CHECK_ACCOUNT_NUMBER | High correlation |
CHECK_ACCOUNT_NUMBER is highly correlated with TXN_CHANNEL_CODE | High correlation |
COUNTRY_OF_ORIGIN is highly correlated with CITY and 2 other fields | High correlation |
CITY is highly correlated with COUNTRY_OF_ORIGIN and 2 other fields | High correlation |
COUNTRY_OF_RESIDENCE is highly correlated with CITY and 2 other fields | High correlation |
DATE_OPENED is highly correlated with DATE_CLOSED | High correlation |
DATE_CLOSED is highly correlated with DATE_OPENED | High correlation |
GENDER_CODE is highly correlated with CITY and 2 other fields | High correlation |
ACCOUNT_ON_HOLD_FLAG has 508031 (100.0%) missing values | Missing |
ACCOUNT_STATUS_CODE has 508031 (100.0%) missing values | Missing |
ANN_PREMIUM_AMT has 508031 (100.0%) missing values | Missing |
BUSINESS_SEGMENT_1 has 508031 (100.0%) missing values | Missing |
CANCELLED_DATE has 508031 (100.0%) missing values | Missing |
CASH_SURR_VALUE has 508031 (100.0%) missing values | Missing |
COLLECTED_BALANCE has 508031 (100.0%) missing values | Missing |
COMMENTS has 508031 (100.0%) missing values | Missing |
COMPANY_NAME has 508031 (100.0%) missing values | Missing |
CUSTOMER_INITIATED_CLOSURE has 508031 (100.0%) missing values | Missing |
CUSTOMER_ID has 508031 (100.0%) missing values | Missing |
CUSTOMER_TYPE has 508031 (100.0%) missing values | Missing |
DEATH_BENEFIT_AMT has 508031 (100.0%) missing values | Missing |
DELAYED_ACCOUNT_FLAG has 508031 (100.0%) missing values | Missing |
DELIVERY_INSTRUCTIONS has 508031 (100.0%) missing values | Missing |
EMPLOYEE_NUMBER has 508031 (100.0%) missing values | Missing |
ERROR_CORRECT_FLAG has 508031 (100.0%) missing values | Missing |
GENDER_CODE has 54847 (10.8%) missing values | Missing |
GROSS_PREM_TTD has 508031 (100.0%) missing values | Missing |
HOLDING_BANK_NAME has 508031 (100.0%) missing values | Missing |
INST_PREMIUM_AMT has 508031 (100.0%) missing values | Missing |
LANGUAGE_PREF_CODE has 508031 (100.0%) missing values | Missing |
MATURITY_DATE has 508031 (100.0%) missing values | Missing |
OTHER_HOLD_AMOUNT has 508031 (100.0%) missing values | Missing |
PERSON_TITLE has 508031 (100.0%) missing values | Missing |
PRIMARY_CARD_ID has 508031 (100.0%) missing values | Missing |
PRIMARY_CUSTOMER_CATEGORY_CODE has 508031 (100.0%) missing values | Missing |
REGISTERED_NUMBER has 508031 (100.0%) missing values | Missing |
RUN_TIMESTAMP has 508031 (100.0%) missing values | Missing |
SALARY_LODGED_FLAG has 508031 (100.0%) missing values | Missing |
SENT_CORRESPONDENCE_FLAG has 508031 (100.0%) missing values | Missing |
SETTLEMENT_BANK_NAME has 508031 (100.0%) missing values | Missing |
SETTLEMENT_TYPE has 508031 (100.0%) missing values | Missing |
SINGLE_PREMIUM_TOTAL has 508031 (100.0%) missing values | Missing |
SOURCE_SYSTEM_CODE has 508031 (100.0%) missing values | Missing |
SUB_DIVISION has 508031 (100.0%) missing values | Missing |
SUM_INSURED has 508031 (100.0%) missing values | Missing |
TO_DATE has 508031 (100.0%) missing values | Missing |
TOTAL_DEPOSITS_BASE has 508031 (100.0%) missing values | Missing |
TRANSACTION_LOCATION has 508031 (100.0%) missing values | Missing |
TURNOVER_FROM_DATE has 508031 (100.0%) missing values | Missing |
TURNOVER_TO_DATE has 508031 (100.0%) missing values | Missing |
ISSUE_DATE is uniformly distributed | Uniform |
ORIGINATION_DATE is uniformly distributed | Uniform |
ACCOUNT_SOURCE_UNIQUE_ID has unique values | Unique |
SOURCE_TXN_NUM has unique values | Unique |
SOURCE_TXN_UNIQUE_ID has unique values | Unique |
ACCOUNT_ON_HOLD_FLAG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ACCOUNT_STATUS_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ANN_PREMIUM_AMT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
BUSINESS_SEGMENT_1 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CANCELLED_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CASH_SURR_VALUE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
COLLECTED_BALANCE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
COMMENTS is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
COMPANY_NAME is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CUSTOMER_INITIATED_CLOSURE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CUSTOMER_ID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CUSTOMER_TYPE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DEATH_BENEFIT_AMT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DELAYED_ACCOUNT_FLAG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DELIVERY_INSTRUCTIONS is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
EMPLOYEE_NUMBER is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ERROR_CORRECT_FLAG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
GROSS_PREM_TTD is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
HOLDING_BANK_NAME is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
INST_PREMIUM_AMT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
LANGUAGE_PREF_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MATURITY_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
OTHER_HOLD_AMOUNT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PERSON_TITLE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
POSTAL_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PRIMARY_CARD_ID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PRIMARY_CUSTOMER_CATEGORY_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
REGISTERED_NUMBER is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
RUN_TIMESTAMP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SALARY_LODGED_FLAG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SENT_CORRESPONDENCE_FLAG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SETTLEMENT_BANK_NAME is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SETTLEMENT_TYPE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SINGLE_PREMIUM_TOTAL is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SOURCE_SYSTEM_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SUB_DIVISION is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
SUM_INSURED is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TO_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TOTAL_DEPOSITS_BASE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TRANSACTION_LOCATION is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TURNOVER_FROM_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TURNOVER_TO_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
BRANCH_ID has 445216 (87.6%) zeros | Zeros |
PRIME_BRANCH_ID has 448137 (88.2%) zeros | Zeros |
RELATIONSHIP_MGR_ID has 448137 (88.2%) zeros | Zeros |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 508031 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| DIARIO |
|---|
| Value | Count | Frequency (%) | |
| DIARIO | 508031 | 100.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 508031 | 100.0% |
| Distinct count | 508031 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| ACC-CUST-20907 | 1 |
|---|---|
| ACC-CUST-1025 | 1 |
| ACC-CUST-422374 | 1 |
| ACC-CUST-497502 | 1 |
| ACC-CUST-182044 | 1 |
| Other values (508026) |
| Value | Count | Frequency (%) | |
| ACC-CUST-20907 | 1 | < 0.1% | |
| ACC-CUST-1025 | 1 | < 0.1% | |
| ACC-CUST-422374 | 1 | < 0.1% | |
| ACC-CUST-497502 | 1 | < 0.1% | |
| ACC-CUST-182044 | 1 | < 0.1% | |
| ACC-CUST-97242 | 1 | < 0.1% | |
| ACC-CUST-101693 | 1 | < 0.1% | |
| ACC-CUST-338329 | 1 | < 0.1% | |
| ACC-CUST-379799 | 1 | < 0.1% | |
| ACC-CUST-435197 | 1 | < 0.1% | |
| Other values (508021) | 508021 | > 99.9% |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.78348172 |
| Min length | 13 |
ACQUISITION_DATE
Real number (ℝ≥0)
| Distinct count | 50110 |
|---|---|
| Unique (%) | 9.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26027.56291053105 |
|---|---|
| Minimum | 2008 |
| Maximum | 52117 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 2008 |
|---|---|
| 5-th percentile | 4317 |
| Q1 | 13554 |
| median | 25702 |
| Q3 | 38403 |
| 95-th percentile | 48563 |
| Maximum | 52117 |
| Range | 50109 |
| Interquartile range (IQR) | 24849 |
Descriptive statistics
| Standard deviation | 14274.75535 |
|---|---|
| Coefficient of variation (CV) | 0.548447636 |
| Kurtosis | -1.210784941 |
| Mean | 26027.56291 |
| Median Absolute Deviation (MAD) | 12411 |
| Skewness | 0.05638853844 |
| Sum | 1.322280881e+10 |
| Variance | 203768640.3 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 11 | < 0.1% | |
| 9338 | 11 | < 0.1% | |
| 5244 | 11 | < 0.1% | |
| 7293 | 11 | < 0.1% | |
| 3199 | 11 | < 0.1% | |
| 17782 | 11 | < 0.1% | |
| 13688 | 11 | < 0.1% | |
| 15737 | 11 | < 0.1% | |
| 9594 | 11 | < 0.1% | |
| 11643 | 11 | < 0.1% | |
| Other values (50100) | 507921 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2008 | 11 | < 0.1% | |
| 2009 | 11 | < 0.1% | |
| 2010 | 11 | < 0.1% | |
| 2011 | 11 | < 0.1% | |
| 2012 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 52117 | 5 | < 0.1% | |
| 52116 | 5 | < 0.1% | |
| 52115 | 5 | < 0.1% | |
| 52114 | 5 | < 0.1% | |
| 52113 | 5 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 2018 |
|---|
| Value | Count | Frequency (%) | |
| 2018 | 508031 | 100.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| N |
|---|
| Value | Count | Frequency (%) | |
| N | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| HIGH ACTIVITY |
|---|
| Value | Count | Frequency (%) | |
| HIGH ACTIVITY | 508031 | 100.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Y |
|---|
| Value | Count | Frequency (%) | |
| Y | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2921 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6659242541228644 |
|---|---|
| Minimum | 0.0 |
| Maximum | 9.0 |
| Zeros | 445216 |
| Zeros (%) | 87.6% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.045329575 |
|---|---|
| Coefficient of variation (CV) | 3.071414748 |
| Kurtosis | 8.320709105 |
| Mean | 0.6659242541 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.110155732 |
| Sum | 336365 |
| Variance | 4.18337307 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 445216 | 87.6% | |
| 7 | 23374 | 4.6% | |
| 2 | 18624 | 3.7% | |
| 9 | 12783 | 2.5% | |
| 4 | 5113 | 1.0% | |
| (Missing) | 2921 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 445216 | 87.6% | |
| 2 | 18624 | 3.7% | |
| 4 | 5113 | 1.0% | |
| 7 | 23374 | 4.6% | |
| 9 | 12783 | 2.5% |
| Value | Count | Frequency (%) | |
| 9 | 12783 | 2.5% | |
| 7 | 23374 | 4.6% | |
| 4 | 5113 | 1.0% | |
| 2 | 18624 | 3.7% | |
| 0 | 445216 | 87.6% |
BUSINESS_TYPE
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Cooperative | |
|---|---|
| ybrid BusinessAsia | 52266 |
| Merchandising Business | 51197 |
| Service Business. | 27949 |
| Value | Count | Frequency (%) | |
| Cooperative | 376619 | 74.1% | |
| ybrid BusinessAsia | 52266 | 10.3% | |
| Merchandising Business | 51197 | 10.1% | |
| Service Business. | 27949 | 5.5% |
Length
| Max length | 22 |
|---|---|
| Median length | 11 |
| Mean length | 13.15877181 |
| Min length | 11 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| INTERNET |
|---|
| Value | Count | Frequency (%) | |
| INTERNET | 508031 | 100.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct count | 72542 |
|---|---|
| Unique (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11415.434400656653 |
|---|---|
| Minimum | 1 |
| Maximum | 73767 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 1234 |
| median | 1234 |
| Q3 | 10264 |
| 95-th percentile | 61066.5 |
| Maximum | 73767 |
| Range | 73766 |
| Interquartile range (IQR) | 9030 |
Descriptive statistics
| Standard deviation | 19932.86649 |
|---|---|
| Coefficient of variation (CV) | 1.74613298 |
| Kurtosis | 1.755315673 |
| Mean | 11415.4344 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.774092032 |
| Sum | 5799394554 |
| Variance | 397319166.4 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1234 | 290754 | 57.2% | |
| 2 | 16626 | 3.3% | |
| 5 | 13148 | 2.6% | |
| 1 | 12963 | 2.6% | |
| 10 | 10590 | 2.1% | |
| 12 | 8035 | 1.6% | |
| 21 | 5113 | 1.0% | |
| 13 | 3177 | 0.6% | |
| 3 | 2558 | 0.5% | |
| 13429 | 3 | < 0.1% | |
| Other values (72532) | 145064 | 28.6% |
| Value | Count | Frequency (%) | |
| 1 | 12963 | 2.6% | |
| 2 | 16626 | 3.3% | |
| 3 | 2558 | 0.5% | |
| 5 | 13148 | 2.6% | |
| 10 | 10590 | 2.1% |
| Value | Count | Frequency (%) | |
| 73767 | 2 | < 0.1% | |
| 73766 | 2 | < 0.1% | |
| 73765 | 2 | < 0.1% | |
| 73764 | 2 | < 0.1% | |
| 73763 | 2 | < 0.1% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| China | |
|---|---|
| Madrid | 51695 |
| New York | 42981 |
| Value | Count | Frequency (%) | |
| China | 413355 | 81.4% | |
| Madrid | 51695 | 10.2% | |
| New York | 42981 | 8.5% |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.355564916 |
| Min length | 5 |
COMPANY_FORM
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| SL | |
|---|---|
| PARTICULAR | 28680 |
| SA | 23738 |
| SC | 8036 |
| ASOCIACION | 8034 |
| Other values (2) | 4017 |
| Value | Count | Frequency (%) | |
| SL | 435526 | 85.7% | |
| PARTICULAR | 28680 | 5.6% | |
| SA | 23738 | 4.7% | |
| SC | 8036 | 1.6% | |
| ASOCIACION | 8034 | 1.6% | |
| SSL | 2922 | 0.6% | |
| Asociacion | 1095 | 0.2% |
Length
| Max length | 10 |
|---|---|
| Median length | 2 |
| Mean length | 2.601132608 |
| Min length | 2 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| China | |
|---|---|
| Spain | 51695 |
| EEUU | 42981 |
| Value | Count | Frequency (%) | |
| China | 413355 | 81.4% | |
| Spain | 51695 | 10.2% | |
| EEUU | 42981 | 8.5% |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.915396895 |
| Min length | 4 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| China | |
|---|---|
| Spain | 51695 |
| Mexico | 42981 |
| Value | Count | Frequency (%) | |
| China | 413355 | 81.4% | |
| Spain | 51695 | 10.2% | |
| Mexico | 42981 | 8.5% |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.084603105 |
| Min length | 5 |
CREDIT_DEBIT_CODE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| C | |
|---|---|
| D | 366 |
| Value | Count | Frequency (%) | |
| C | 507665 | 99.9% | |
| D | 366 | 0.1% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 2000 |
|---|
| Value | Count | Frequency (%) | |
| 2000 | 508031 | 100.0% |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Y |
|---|
| Value | Count | Frequency (%) | |
| Y | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| EUR |
|---|
| Value | Count | Frequency (%) | |
| EUR | 508031 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
CURRENCY_CODE_BASE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2921 |
| Missing (%) | 0.6% |
| Memory size | 3.9 MiB |
| EUR | |
|---|---|
| DOL | |
| GBR | 366 |
| Value | Count | Frequency (%) | |
| EUR | 414161 | 81.5% | |
| DOL | 90583 | 17.8% | |
| GBR | 366 | 0.1% | |
| (Missing) | 2921 | 0.6% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
CURRENCY_CODE_ORIG
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2921 |
| Missing (%) | 0.6% |
| Memory size | 3.9 MiB |
| EUR | |
|---|---|
| DOL | |
| GBR | 6574 |
| Value | Count | Frequency (%) | |
| EUR | 395901 | 77.9% | |
| DOL | 102635 | 20.2% | |
| GBR | 6574 | 1.3% | |
| (Missing) | 2921 | 0.6% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 508031 | 100.0% |
CUSTOMER_SOURCE_UNIQUE_ID
Categorical
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| CUSTTM-0014 | 48384 |
|---|---|
| CUSTTM-0002 | 48384 |
| CUSTTM-0003 | 48384 |
| CUSTTM-0001 | 48384 |
| CUSTTM-0017 | 48384 |
| Other values (12) |
| Value | Count | Frequency (%) | |
| CUSTTM-0014 | 48384 | 9.5% | |
| CUSTTM-0002 | 48384 | 9.5% | |
| CUSTTM-0003 | 48384 | 9.5% | |
| CUSTTM-0001 | 48384 | 9.5% | |
| CUSTTM-0017 | 48384 | 9.5% | |
| CUSTTM-0007 | 48384 | 9.5% | |
| CUSTTM-0006 | 48384 | 9.5% | |
| CUSTTM-0015 | 48384 | 9.5% | |
| CUSTTM-0016 | 24192 | 4.8% | |
| CUSTTM-0012 | 12096 | 2.4% | |
| Other values (7) | 84671 | 16.7% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 508031 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| P |
|---|
| Value | Count | Frequency (%) | |
| P | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.9 MiB |
| 01/01/2010 | |
|---|---|
| 03/01/2010 | 33 |
| 04/01/2010 | 33 |
| 02/01/2010 | 32 |
| Value | Count | Frequency (%) | |
| 01/01/2010 | 507932 | > 99.9% | |
| 03/01/2010 | 33 | < 0.1% | |
| 04/01/2010 | 33 | < 0.1% | |
| 02/01/2010 | 32 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999986221 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.9 MiB |
| 01/01/2010 | |
|---|---|
| 03/01/2010 | 33 |
| 04/01/2010 | 33 |
| 02/01/2010 | 32 |
| Value | Count | Frequency (%) | |
| 01/01/2010 | 507932 | > 99.9% | |
| 03/01/2010 | 33 | < 0.1% | |
| 04/01/2010 | 33 | < 0.1% | |
| 02/01/2010 | 32 | < 0.1% | |
| (Missing) | 1 | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999986221 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| N |
|---|
| Value | Count | Frequency (%) | |
| N | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
DEVICE_ID
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Web | |
|---|---|
| App | 77433 |
| ATM | 20816 |
| Mobile | 730 |
| Branch | 366 |
| Value | Count | Frequency (%) | |
| Web | 408321 | 80.4% | |
| App | 77433 | 15.2% | |
| ATM | 20816 | 4.1% | |
| Mobile | 730 | 0.1% | |
| Branch | 366 | 0.1% | |
| 8 | 365 | 0.1% |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.005035126 |
| Min length | 1 |
EMPLOYEE_FLAG
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| N | |
|---|---|
| Y | 51695 |
| Value | Count | Frequency (%) | |
| N | 456336 | 89.8% | |
| Y | 51695 | 10.2% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Desempleado |
|---|
| Value | Count | Frequency (%) | |
| Desempleado | 508031 | 100.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
FILTER
Real number (ℝ≥0)
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2922 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2031.5881384018103 |
|---|---|
| Minimum | 2020.0 |
| Maximum | 2042.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 2020 |
|---|---|
| 5-th percentile | 2021 |
| Q1 | 2028 |
| median | 2033 |
| Q3 | 2038 |
| 95-th percentile | 2042 |
| Maximum | 2042 |
| Range | 22 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 7.139984691 |
|---|---|
| Coefficient of variation (CV) | 0.003514484337 |
| Kurtosis | -1.178660127 |
| Mean | 2031.588138 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.3169608147 |
| Sum | 1026173453 |
| Variance | 50.97938138 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2021 | 120861 | 23.8% | |
| 2042 | 27933 | 5.5% | |
| 2029 | 25511 | 5.0% | |
| 2041 | 25254 | 5.0% | |
| 2036 | 25254 | 5.0% | |
| 2032 | 25254 | 5.0% | |
| 2030 | 25185 | 5.0% | |
| 2031 | 25185 | 5.0% | |
| 2033 | 25185 | 5.0% | |
| 2034 | 25185 | 5.0% | |
| Other values (7) | 154302 | 30.4% |
| Value | Count | Frequency (%) | |
| 2020 | 3315 | 0.7% | |
| 2021 | 120861 | 23.8% | |
| 2028 | 25062 | 4.9% | |
| 2029 | 25511 | 5.0% | |
| 2030 | 25185 | 5.0% |
| Value | Count | Frequency (%) | |
| 2042 | 27933 | 5.5% | |
| 2041 | 25254 | 5.0% | |
| 2040 | 25185 | 5.0% | |
| 2039 | 25185 | 5.0% | |
| 2038 | 25185 | 5.0% |
FROM_DATE
Categorical
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.9 MiB |
| 01/01/2009 |
|---|
| Value | Count | Frequency (%) | |
| 01/01/2009 | 508030 | > 99.9% | |
| (Missing) | 1 | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999986221 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 54847 |
| Missing (%) | 10.8% |
| Memory size | 3.9 MiB |
| M | |
|---|---|
| H | 53157 |
| Value | Count | Frequency (%) | |
| M | 400027 | 78.7% | |
| H | 53157 | 10.5% | |
| (Missing) | 54847 | 10.8% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.215919895 |
| Min length | 1 |
INCORPORATION_COUNTRY_CODE
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.9 MiB |
| ESP | |
|---|---|
| UK | 8035 |
| GER | 8034 |
| FR | 6574 |
| SUE | 5113 |
| Other values (7) | 18627 |
| Value | Count | Frequency (%) | |
| ESP | 461647 | 90.9% | |
| UK | 8035 | 1.6% | |
| GER | 8034 | 1.6% | |
| FR | 6574 | 1.3% | |
| SUE | 5113 | 1.0% | |
| IQ | 5113 | 1.0% | |
| IR | 5113 | 1.0% | |
| POR | 4382 | 0.9% | |
| IT | 1096 | 0.2% | |
| EEUU | 1096 | 0.2% | |
| Other values (2) | 1827 | 0.4% |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.951115188 |
| Min length | 2 |
INCORPORATION_DATE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 01/01/2009 | |
|---|---|
| 0:00:00 | 1 |
| Value | Count | Frequency (%) | |
| 01/01/2009 | 508030 | > 99.9% | |
| 0:00:00 | 1 | < 0.1% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999994095 |
| Min length | 7 |
| Distinct count | 24217 |
|---|---|
| Unique (%) | 4.8% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.9 MiB |
| 13/03/2010 | 21 |
|---|---|
| 25/06/2004 | 21 |
| 14/03/2050 | 21 |
| 12/08/2052 | 21 |
| 10/08/2049 | 21 |
| Other values (24212) |
| Value | Count | Frequency (%) | |
| 13/03/2010 | 21 | < 0.1% | |
| 25/06/2004 | 21 | < 0.1% | |
| 14/03/2050 | 21 | < 0.1% | |
| 12/08/2052 | 21 | < 0.1% | |
| 10/08/2049 | 21 | < 0.1% | |
| 17/12/2063 | 21 | < 0.1% | |
| 08/06/2027 | 21 | < 0.1% | |
| 18/02/2012 | 21 | < 0.1% | |
| 17/09/2020 | 21 | < 0.1% | |
| 01/07/2011 | 21 | < 0.1% | |
| Other values (24207) | 507820 | > 99.9% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999986221 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 508031 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Camarero |
|---|
| Value | Count | Frequency (%) | |
| Camarero | 508031 | 100.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| RET |
|---|
| Value | Count | Frequency (%) | |
| RET | 508031 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 24218 |
|---|---|
| Unique (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 13/03/2010 | 21 |
|---|---|
| 29/05/2007 | 21 |
| 07/10/2067 | 21 |
| 28/02/2015 | 21 |
| 09/09/2055 | 21 |
| Other values (24213) |
| Value | Count | Frequency (%) | |
| 13/03/2010 | 21 | < 0.1% | |
| 29/05/2007 | 21 | < 0.1% | |
| 07/10/2067 | 21 | < 0.1% | |
| 28/02/2015 | 21 | < 0.1% | |
| 09/09/2055 | 21 | < 0.1% | |
| 19/05/2034 | 21 | < 0.1% | |
| 18/11/2054 | 21 | < 0.1% | |
| 17/10/2054 | 21 | < 0.1% | |
| 08/05/2046 | 21 | < 0.1% | |
| 29/06/2017 | 21 | < 0.1% | |
| Other values (24208) | 507821 | > 99.9% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.999994095 |
| Min length | 7 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 508031 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Diario |
|---|
| Value | Count | Frequency (%) | |
| Diario | 508031 | 100.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Transferencia |
|---|
| Value | Count | Frequency (%) | |
| Transferencia | 508031 | 100.0% |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 508031 | 100.0% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6620954233107822 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 448137 |
| Zeros (%) | 88.2% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.040062536 |
|---|---|
| Coefficient of variation (CV) | 3.081221323 |
| Kurtosis | 8.39578829 |
| Mean | 0.6620954233 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.121716638 |
| Sum | 336365 |
| Variance | 4.161855152 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 448137 | 88.2% | |
| 7 | 23374 | 4.6% | |
| 2 | 18624 | 3.7% | |
| 9 | 12783 | 2.5% | |
| 4 | 5113 | 1.0% |
| Value | Count | Frequency (%) | |
| 0 | 448137 | 88.2% | |
| 2 | 18624 | 3.7% | |
| 4 | 5113 | 1.0% | |
| 7 | 23374 | 4.6% | |
| 9 | 12783 | 2.5% |
| Value | Count | Frequency (%) | |
| 9 | 12783 | 2.5% | |
| 7 | 23374 | 4.6% | |
| 4 | 5113 | 1.0% | |
| 2 | 18624 | 3.7% | |
| 0 | 448137 | 88.2% |
| Distinct count | 10966 |
|---|---|
| Unique (%) | 2.2% |
| Missing | 2921 |
| Missing (%) | 0.6% |
| Memory size | 3.9 MiB |
| TT0001 | 25620 |
|---|---|
| 8 | 10956 |
| 5 | 8765 |
| 2 | 7669 |
| 7 | 6210 |
| Other values (10961) |
| Value | Count | Frequency (%) | |
| TT0001 | 25620 | 5.0% | |
| 8 | 10956 | 2.2% | |
| 5 | 8765 | 1.7% | |
| 2 | 7669 | 1.5% | |
| 7 | 6210 | 1.2% | |
| 6 | 5478 | 1.1% | |
| 4 | 5113 | 1.0% | |
| 9 | 5113 | 1.0% | |
| 1 | 4747 | 0.9% | |
| 0005 | 2944 | 0.6% | |
| Other values (10956) | 422495 | 83.2% | |
| (Missing) | 2921 | 0.6% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.161759814 |
| Min length | 1 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6620954233107822 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 448137 |
| Zeros (%) | 88.2% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.040062536 |
|---|---|
| Coefficient of variation (CV) | 3.081221323 |
| Kurtosis | 8.39578829 |
| Mean | 0.6620954233 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.121716638 |
| Sum | 336365 |
| Variance | 4.161855152 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 448137 | 88.2% | |
| 7 | 23374 | 4.6% | |
| 2 | 18624 | 3.7% | |
| 9 | 12783 | 2.5% | |
| 4 | 5113 | 1.0% |
| Value | Count | Frequency (%) | |
| 0 | 448137 | 88.2% | |
| 2 | 18624 | 3.7% | |
| 4 | 5113 | 1.0% | |
| 7 | 23374 | 4.6% | |
| 9 | 12783 | 2.5% |
| Value | Count | Frequency (%) | |
| 9 | 12783 | 2.5% | |
| 7 | 23374 | 4.6% | |
| 4 | 5113 | 1.0% | |
| 2 | 18624 | 3.7% | |
| 0 | 448137 | 88.2% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Y |
|---|
| Value | Count | Frequency (%) | |
| Y | 508031 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| PEP |
|---|
| Value | Count | Frequency (%) | |
| PEP | 508031 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 100 |
|---|
| Value | Count | Frequency (%) | |
| 100 | 508031 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 508031 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| TXN-CUSTTM-292260 | 1 |
|---|---|
| TXN-CUSTTM-55885 | 1 |
| TXN-CUSTTM-167210 | 1 |
| TXN-CUSTTM-297336 | 1 |
| TXN-CUSTTM-391351 | 1 |
| Other values (508026) |
| Value | Count | Frequency (%) | |
| TXN-CUSTTM-292260 | 1 | < 0.1% | |
| TXN-CUSTTM-55885 | 1 | < 0.1% | |
| TXN-CUSTTM-167210 | 1 | < 0.1% | |
| TXN-CUSTTM-297336 | 1 | < 0.1% | |
| TXN-CUSTTM-391351 | 1 | < 0.1% | |
| TXN-CUSTTM-486516 | 1 | < 0.1% | |
| TXN-CUSTTM-142091 | 1 | < 0.1% | |
| TXN-CUSTTM-497161 | 1 | < 0.1% | |
| TXN-CUSTTM-498288 | 1 | < 0.1% | |
| TXN-CUSTTM-440254 | 1 | < 0.1% | |
| Other values (508021) | 508021 | > 99.9% |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.78348172 |
| Min length | 15 |
| Distinct count | 508031 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| TXN-CUSTTM-292260 | 1 |
|---|---|
| TXN-CUSTTM-55885 | 1 |
| TXN-CUSTTM-167210 | 1 |
| TXN-CUSTTM-297336 | 1 |
| TXN-CUSTTM-391351 | 1 |
| Other values (508026) |
| Value | Count | Frequency (%) | |
| TXN-CUSTTM-292260 | 1 | < 0.1% | |
| TXN-CUSTTM-55885 | 1 | < 0.1% | |
| TXN-CUSTTM-167210 | 1 | < 0.1% | |
| TXN-CUSTTM-297336 | 1 | < 0.1% | |
| TXN-CUSTTM-391351 | 1 | < 0.1% | |
| TXN-CUSTTM-486516 | 1 | < 0.1% | |
| TXN-CUSTTM-142091 | 1 | < 0.1% | |
| TXN-CUSTTM-497161 | 1 | < 0.1% | |
| TXN-CUSTTM-498288 | 1 | < 0.1% | |
| TXN-CUSTTM-440254 | 1 | < 0.1% | |
| Other values (508021) | 508021 | > 99.9% |
Length
| Max length | 17 |
|---|---|
| Median length | 17 |
| Mean length | 16.78348172 |
| Min length | 15 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 200 |
|---|
| Value | Count | Frequency (%) | |
| 200 | 508031 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
TXN_AMOUNT_ORIG
Real number (ℝ≥0)
| Distinct count | 72539 |
|---|---|
| Unique (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9874.674927317428 |
|---|---|
| Minimum | 1 |
| Maximum | 73784 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 3000 |
| median | 3000 |
| Q3 | 10000 |
| 95-th percentile | 48382.5 |
| Maximum | 73784 |
| Range | 73783 |
| Interquartile range (IQR) | 7000 |
Descriptive statistics
| Standard deviation | 14728.85146 |
|---|---|
| Coefficient of variation (CV) | 1.491578363 |
| Kurtosis | 6.005497049 |
| Mean | 9874.674927 |
| Median Absolute Deviation (MAD) | 1749 |
| Skewness | 2.527601214 |
| Sum | 5016640978 |
| Variance | 216939065.3 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3000 | 204737 | 40.3% | |
| 1000 | 53415 | 10.5% | |
| 1251 | 32580 | 6.4% | |
| 9000 | 10231 | 2.0% | |
| 8000 | 9068 | 1.8% | |
| 6789 | 8041 | 1.6% | |
| 10000 | 5375 | 1.1% | |
| 5000 | 5120 | 1.0% | |
| 4599 | 5120 | 1.0% | |
| 1 | 2921 | 0.6% | |
| Other values (72529) | 171423 | 33.7% |
| Value | Count | Frequency (%) | |
| 1 | 2921 | 0.6% | |
| 999 | 257 | 0.1% | |
| 1000 | 53415 | 10.5% | |
| 1001 | 514 | 0.1% | |
| 1249 | 257 | 0.1% |
| Value | Count | Frequency (%) | |
| 73784 | 1 | < 0.1% | |
| 73783 | 1 | < 0.1% | |
| 73782 | 1 | < 0.1% | |
| 73781 | 1 | < 0.1% | |
| 73780 | 1 | < 0.1% |
| Distinct count | 72536 |
|---|---|
| Unique (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10360.240241245121 |
|---|---|
| Minimum | 1 |
| Maximum | 72537 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 4 |
| median | 4 |
| Q3 | 9034 |
| 95-th percentile | 59836.5 |
| Maximum | 72537 |
| Range | 72536 |
| Interquartile range (IQR) | 9030 |
Descriptive statistics
| Standard deviation | 19837.20974 |
|---|---|
| Coefficient of variation (CV) | 1.914744184 |
| Kurtosis | 1.778753579 |
| Mean | 10360.24024 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.781279239 |
| Sum | 5263323210 |
| Variance | 393514890.4 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 4 | 291119 | 57.3% | |
| 7 | 50483 | 9.9% | |
| 8 | 9499 | 1.9% | |
| 2 | 5111 | 1.0% | |
| 1 | 4198 | 0.8% | |
| 5 | 1464 | 0.3% | |
| 6 | 1098 | 0.2% | |
| 12199 | 3 | < 0.1% | |
| 22878 | 2 | < 0.1% | |
| 26968 | 2 | < 0.1% | |
| Other values (72526) | 145052 | 28.6% |
| Value | Count | Frequency (%) | |
| 1 | 4198 | 0.8% | |
| 2 | 5111 | 1.0% | |
| 4 | 291119 | 57.3% | |
| 5 | 1464 | 0.3% | |
| 6 | 1098 | 0.2% |
| Value | Count | Frequency (%) | |
| 72537 | 2 | < 0.1% | |
| 72536 | 2 | < 0.1% | |
| 72535 | 2 | < 0.1% | |
| 72534 | 2 | < 0.1% | |
| 72533 | 2 | < 0.1% |
| Distinct count | 9030 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 2921 |
| Missing (%) | 0.6% |
| Memory size | 3.9 MiB |
| TT001 | 43150 |
|---|---|
| TT002 | 10287 |
| TT005 | 8096 |
| TT008 | 5174 |
| 6 | 5113 |
| Other values (9025) |
| Value | Count | Frequency (%) | |
| TT001 | 43150 | 8.5% | |
| TT002 | 10287 | 2.0% | |
| TT005 | 8096 | 1.6% | |
| TT008 | 5174 | 1.0% | |
| 6 | 5113 | 1.0% | |
| 5 | 2921 | 0.6% | |
| 4 | 2921 | 0.6% | |
| TT0024 | 393 | 0.1% | |
| TT0028 | 391 | 0.1% | |
| TT0030 | 390 | 0.1% | |
| Other values (9020) | 426274 | 83.9% | |
| (Missing) | 2921 | 0.6% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.625479548 |
| Min length | 1 |
TXN_STATUS_CODE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| ACTIVE | |
|---|---|
| INACTIVE | 4383 |
| INACT | 365 |
| Value | Count | Frequency (%) | |
| ACTIVE | 503283 | 99.1% | |
| INACTIVE | 4383 | 0.9% | |
| INACT | 365 | 0.1% |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.016536392 |
| Min length | 5 |
ZONE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Asia | |
|---|---|
| EEUU | 51197 |
| Europe | 45479 |
| Value | Count | Frequency (%) | |
| Asia | 411355 | 81.0% | |
| EEUU | 51197 | 10.1% | |
| Europe | 45479 | 9.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.179040255 |
| Min length | 4 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| ACCOUNT_BALANCE | ACCOUNT_ON_HOLD_FLAG | ACCOUNT_PURPOSE | ACCOUNT_SEGMENT | ACCOUNT_SOURCE_UNIQUE_ID | ACCOUNT_STATUS_CODE | ACQUISITION_DATE | ANN_PREMIUM_AMT | BALANCE_DATE | BENEFICIARY_FLAG | BLOCKED_REASON | BLOCKED_TYPE | BRANCH_ID | BUSINESS_SEGMENT_1 | BUSINESS_TYPE | CANCELLED_DATE | CASH_SURR_VALUE | CHANNEL_OF_OPENING | CHECK_ACCOUNT_NUMBER | CITY | COLLECTED_BALANCE | COMMENTS | COMPANY_FORM | COMPANY_NAME | COUNTRY_OF_ORIGIN | COUNTRY_OF_RESIDENCE | CREDIT_DEBIT_CODE | CREDIT_LIMIT | CREDIT_TURNOVER | CURRENCY_CODE | CURRENCY_CODE_BASE | CURRENCY_CODE_ORIG | CUSTOMER_INITIATED_CLOSURE | CUSTOMER_SEGMENT_1 | CUSTOMER_SOURCE_UNIQUE_ID | CUSTOMER_ID | CUSTOMER_STATUS_CODE | CUSTOMER_TYPE | CUSTOMER_TYPE_CODE | DATE_CLOSED | DATE_OPENED | DEATH_BENEFIT_AMT | DEBIT_TRUNOVER | DELAYED_ACCOUNT_FLAG | DELIVERY_INSTRUCTIONS | DEVICE_ID | EMPLOYEE_FLAG | EMPLOYEE_NUMBER | EMPLOYMENT_STATUS | ERROR_CORRECT_FLAG | FILTER | FROM_DATE | GENDER_CODE | GROSS_PREM_TTD | HOLDING_BANK_NAME | INCORPORATION_COUNTRY_CODE | INCORPORATION_DATE | INST_PREMIUM_AMT | ISSUE_DATE | LANGUAGE_PREF_CODE | LIFE_INS_CONTRACT_DURATION | MATURITY_DATE | OCCUPATION | ORG_UNIT_CODE | ORIGINATION_DATE | OTHER_HOLD_AMOUNT | OVERDRAFT_LIMIT | PAYMENT_FREQ | PAYMENT_METHOD | PERIODIC_LOAN_AMOUNT | PERSON_TITLE | POSTAL_CODE | PRIMARY_CARD_ID | PRIMARY_CUSTOMER_CATEGORY_CODE | PRIME_BRANCH_ID | PRODUCT_SOURCE_TYPE_CODE | REGISTERED_NUMBER | RELATIONSHIP_MGR_ID | REPORTING_REGION | RISK_CATEGORY | RISK_SCORE | RUN_TIMESTAMP | SALARY_LODGED_FLAG | SENT_CORRESPONDENCE_FLAG | SETTLEMENT_BANK_NAME | SETTLEMENT_TYPE | SINGLE_PREMIUM_TOTAL | SOURCE_SYSTEM_CODE | SOURCE_TXN_NUM | SOURCE_TXN_UNIQUE_ID | SUB_DIVISION | SUM_INSURED | TO_DATE | TOTAL_DEPOSITS_BASE | TOTAL_LOANS_BASE | TRANSACTION_LOCATION | TURNOVER_FROM_DATE | TURNOVER_TO_DATE | TXN_AMOUNT_ORIG | TXN_CHANNEL_CODE | TXN_SOURCE_TYPE_CODE | TXN_STATUS_CODE | ZONE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | NaN | DIARIO | 1 | ACC-CUST-0001 | NaN | 2008 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0014 | NaN | 1 | NaN | P | 03/01/2010 | 03/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 04/03/2004 | NaN | 0 | NaN | Camarero | RET | 04/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28028 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0001 | TXN-CUSTTM-0001 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 1000 | 5 | TT0024 | INACTIVE | Europe |
| 1 | 0 | NaN | DIARIO | 1 | ACC-CUST-0002 | NaN | 2009 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0014 | NaN | 1 | NaN | P | 04/01/2010 | 04/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 05/03/2004 | NaN | 0 | NaN | Camarero | RET | 05/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28029 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0002 | TXN-CUSTTM-0002 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 3000 | 5 | TT0024 | INACTIVE | Europe |
| 2 | 0 | NaN | DIARIO | 1 | ACC-CUST-0003 | NaN | 2010 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0014 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 06/03/2004 | NaN | 0 | NaN | Camarero | RET | 06/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28030 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0003 | TXN-CUSTTM-0003 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 1000 | 5 | TT0024 | INACTIVE | Europe |
| 3 | 0 | NaN | DIARIO | 1 | ACC-CUST-0004 | NaN | 2011 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0014 | NaN | 1 | NaN | P | 02/01/2010 | 02/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 07/03/2004 | NaN | 0 | NaN | Camarero | RET | 07/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28031 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0004 | TXN-CUSTTM-0004 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 1001 | 5 | TT0024 | INACTIVE | Europe |
| 4 | 0 | NaN | DIARIO | 1 | ACC-CUST-0005 | NaN | 2012 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0015 | NaN | 1 | NaN | P | 03/01/2010 | 03/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 08/03/2004 | NaN | 0 | NaN | Camarero | RET | 08/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28032 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0005 | TXN-CUSTTM-0005 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 1000 | 5 | TT0024 | INACTIVE | Europe |
| 5 | 0 | NaN | DIARIO | 1 | ACC-CUST-0006 | NaN | 2013 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0015 | NaN | 1 | NaN | P | 04/01/2010 | 04/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 09/03/2004 | NaN | 0 | NaN | Camarero | RET | 09/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28033 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0006 | TXN-CUSTTM-0006 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 3000 | 5 | TT0024 | INACTIVE | Europe |
| 6 | 0 | NaN | DIARIO | 1 | ACC-CUST-0007 | NaN | 2014 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0015 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 10/03/2004 | NaN | 0 | NaN | Camarero | RET | 10/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28034 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0007 | TXN-CUSTTM-0007 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 1000 | 5 | TT0024 | INACTIVE | Europe |
| 7 | 0 | NaN | DIARIO | 1 | ACC-CUST-0008 | NaN | 2015 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0015 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 11/03/2004 | NaN | 0 | NaN | Camarero | RET | 11/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28035 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0008 | TXN-CUSTTM-0008 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 999 | 5 | TT0024 | INACTIVE | Europe |
| 8 | 0 | NaN | DIARIO | 1 | ACC-CUST-0009 | NaN | 2016 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0016 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 12/03/2004 | NaN | 0 | NaN | Camarero | RET | 12/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28036 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0009 | TXN-CUSTTM-0009 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 10000 | 5 | TT0024 | INACTIVE | Europe |
| 9 | 0 | NaN | DIARIO | 1 | ACC-CUST-0010 | NaN | 2017 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Cooperative | NaN | NaN | INTERNET | 1234 | Madrid | NaN | NaN | PARTICULAR | NaN | Spain | Spain | D | 2000 | Y | EUR | DOL | DOL | NaN | 1 | CUSTTM-0016 | NaN | 1 | NaN | P | 02/01/2010 | 02/01/2010 | NaN | N | NaN | NaN | ATM | Y | NaN | Desempleado | NaN | NaN | 01/01/2009 | H | NaN | NaN | ESP | 01/01/2009 | NaN | 13/03/2004 | NaN | 0 | NaN | Camarero | RET | 13/03/2004 | NaN | 0 | Diario | Transferencia | 0 | NaN | 28037 | NaN | NaN | 0 | 0002 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-0010 | TXN-CUSTTM-0010 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 5001 | 5 | TT0024 | INACTIVE | Europe |
Last rows
| ACCOUNT_BALANCE | ACCOUNT_ON_HOLD_FLAG | ACCOUNT_PURPOSE | ACCOUNT_SEGMENT | ACCOUNT_SOURCE_UNIQUE_ID | ACCOUNT_STATUS_CODE | ACQUISITION_DATE | ANN_PREMIUM_AMT | BALANCE_DATE | BENEFICIARY_FLAG | BLOCKED_REASON | BLOCKED_TYPE | BRANCH_ID | BUSINESS_SEGMENT_1 | BUSINESS_TYPE | CANCELLED_DATE | CASH_SURR_VALUE | CHANNEL_OF_OPENING | CHECK_ACCOUNT_NUMBER | CITY | COLLECTED_BALANCE | COMMENTS | COMPANY_FORM | COMPANY_NAME | COUNTRY_OF_ORIGIN | COUNTRY_OF_RESIDENCE | CREDIT_DEBIT_CODE | CREDIT_LIMIT | CREDIT_TURNOVER | CURRENCY_CODE | CURRENCY_CODE_BASE | CURRENCY_CODE_ORIG | CUSTOMER_INITIATED_CLOSURE | CUSTOMER_SEGMENT_1 | CUSTOMER_SOURCE_UNIQUE_ID | CUSTOMER_ID | CUSTOMER_STATUS_CODE | CUSTOMER_TYPE | CUSTOMER_TYPE_CODE | DATE_CLOSED | DATE_OPENED | DEATH_BENEFIT_AMT | DEBIT_TRUNOVER | DELAYED_ACCOUNT_FLAG | DELIVERY_INSTRUCTIONS | DEVICE_ID | EMPLOYEE_FLAG | EMPLOYEE_NUMBER | EMPLOYMENT_STATUS | ERROR_CORRECT_FLAG | FILTER | FROM_DATE | GENDER_CODE | GROSS_PREM_TTD | HOLDING_BANK_NAME | INCORPORATION_COUNTRY_CODE | INCORPORATION_DATE | INST_PREMIUM_AMT | ISSUE_DATE | LANGUAGE_PREF_CODE | LIFE_INS_CONTRACT_DURATION | MATURITY_DATE | OCCUPATION | ORG_UNIT_CODE | ORIGINATION_DATE | OTHER_HOLD_AMOUNT | OVERDRAFT_LIMIT | PAYMENT_FREQ | PAYMENT_METHOD | PERIODIC_LOAN_AMOUNT | PERSON_TITLE | POSTAL_CODE | PRIMARY_CARD_ID | PRIMARY_CUSTOMER_CATEGORY_CODE | PRIME_BRANCH_ID | PRODUCT_SOURCE_TYPE_CODE | REGISTERED_NUMBER | RELATIONSHIP_MGR_ID | REPORTING_REGION | RISK_CATEGORY | RISK_SCORE | RUN_TIMESTAMP | SALARY_LODGED_FLAG | SENT_CORRESPONDENCE_FLAG | SETTLEMENT_BANK_NAME | SETTLEMENT_TYPE | SINGLE_PREMIUM_TOTAL | SOURCE_SYSTEM_CODE | SOURCE_TXN_NUM | SOURCE_TXN_UNIQUE_ID | SUB_DIVISION | SUM_INSURED | TO_DATE | TOTAL_DEPOSITS_BASE | TOTAL_LOANS_BASE | TRANSACTION_LOCATION | TURNOVER_FROM_DATE | TURNOVER_TO_DATE | TXN_AMOUNT_ORIG | TXN_CHANNEL_CODE | TXN_SOURCE_TYPE_CODE | TXN_STATUS_CODE | ZONE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508021 | 0 | NaN | DIARIO | 1 | ACC-CUST-508022 | NaN | 19069 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73758 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0002 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 03/01/2069 | NaN | 0 | NaN | Camarero | RET | 03/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0318 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508022 | TXN-CUSTTM-508022 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6604 | 72528 | TT318 | ACTIVE | EEUU |
| 508022 | 0 | NaN | DIARIO | 1 | ACC-CUST-508023 | NaN | 19070 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73759 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0002 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 04/01/2069 | NaN | 0 | NaN | Camarero | RET | 04/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0319 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508023 | TXN-CUSTTM-508023 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6605 | 72529 | TT319 | ACTIVE | EEUU |
| 508023 | 0 | NaN | DIARIO | 1 | ACC-CUST-508024 | NaN | 19071 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73760 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0003 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 05/01/2069 | NaN | 0 | NaN | Camarero | RET | 05/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0320 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508024 | TXN-CUSTTM-508024 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6606 | 72530 | TT320 | ACTIVE | EEUU |
| 508024 | 0 | NaN | DIARIO | 1 | ACC-CUST-508025 | NaN | 19072 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73761 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0003 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 06/01/2069 | NaN | 0 | NaN | Camarero | RET | 06/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0321 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508025 | TXN-CUSTTM-508025 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6607 | 72531 | TT321 | ACTIVE | EEUU |
| 508025 | 0 | NaN | DIARIO | 1 | ACC-CUST-508026 | NaN | 19073 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73762 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0003 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 07/01/2069 | NaN | 0 | NaN | Camarero | RET | 07/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0322 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508026 | TXN-CUSTTM-508026 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6608 | 72532 | TT322 | ACTIVE | EEUU |
| 508026 | 0 | NaN | DIARIO | 1 | ACC-CUST-508027 | NaN | 19074 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73763 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0003 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 08/01/2069 | NaN | 0 | NaN | Camarero | RET | 08/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0323 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508027 | TXN-CUSTTM-508027 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6609 | 72533 | TT323 | ACTIVE | EEUU |
| 508027 | 0 | NaN | DIARIO | 1 | ACC-CUST-508028 | NaN | 19075 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73764 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0004 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 09/01/2069 | NaN | 0 | NaN | Camarero | RET | 09/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0324 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508028 | TXN-CUSTTM-508028 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6610 | 72534 | TT324 | ACTIVE | EEUU |
| 508028 | 0 | NaN | DIARIO | 1 | ACC-CUST-508029 | NaN | 19076 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73765 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0010 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 10/01/2069 | NaN | 0 | NaN | Camarero | RET | 10/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0325 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508029 | TXN-CUSTTM-508029 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6611 | 72535 | TT325 | ACTIVE | EEUU |
| 508029 | 0 | NaN | DIARIO | 1 | ACC-CUST-508030 | NaN | 19077 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73766 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0011 | NaN | 1 | NaN | P | 01/01/2010 | 01/01/2010 | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | 01/01/2009 | NaN | NaN | NaN | ESP | 01/01/2009 | NaN | 11/01/2069 | NaN | 0 | NaN | Camarero | RET | 11/01/2069 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0326 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508030 | TXN-CUSTTM-508030 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6612 | 72536 | TT326 | ACTIVE | EEUU |
| 508030 | 0 | NaN | DIARIO | 1 | ACC-CUST-508031 | NaN | 19078 | NaN | 2018 | N | HIGH ACTIVITY | Y | 0.0 | NaN | Merchandising Business | NaN | NaN | INTERNET | 73767 | New York | NaN | NaN | SL | NaN | EEUU | Mexico | C | 2000 | Y | EUR | EUR | EUR | NaN | 1 | CUSTTM-0012 | NaN | 1 | NaN | P | NaN | NaN | NaN | N | NaN | NaN | Web | N | NaN | Desempleado | NaN | 2029.0 | NaN | NaN | NaN | NaN | ESP | 0:00:00 | NaN | NaN | NaN | 0 | NaN | Camarero | RET | 0:00:00 | NaN | 0 | Diario | Transferencia | 0 | NaN | 1001 | NaN | NaN | 0 | TT0327 | NaN | 0 | Y | PEP | 100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | TXN-CUSTTM-508031 | TXN-CUSTTM-508031 | NaN | NaN | NaN | NaN | 200 | NaN | NaN | NaN | 6613 | 72537 | TT327 | ACTIVE | EEUU |